module.exports = {
  findAllById: 'SELECT * FROM user WHERE id=?',
  findAllByEmail: 'SELECT * FROM user WHERE email=?',
  findIdByEmail: 'SELECT id FROM user WHERE email=?',
  addUser: `INSERT INTO user(id, email, password, nickname, realname, phone, identity) 
              VALUES(0, ?, ?, ?, ?, ?, ?)`,
  setPasswdByEmail: 'UPDATE user SET password=? WHERE email=?',
  updateById: 'UPDATE user SET nickname=?, realname=?, phone=?, identity=?, avatar=?, address=?, school=?, gender=? WHERE id=?'
}